﻿-- ===============================================================================================
-- Basic View for User Group
-- ===============================================================================================

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[esf_sso].[VUserGroup]'))
	DROP VIEW [esf_sso].[VUserGroup]
GO

-- SELECT * FROM [esf_sso].[VUserGroup]

CREATE VIEW [esf_sso].[VUserGroup] AS
	SELECT * FROM esf_sso.VBasicReference WHERE BasicReferenceTypeID = 5
	
GO